% if Chkrequest(request("id")) then id=request("id") else response.Redirect("../../login/chklogin.asp?login=4") response.end end if sql="select * from productshow where id="&id&"" Set rs= conn.execute(sql) if rs.eof then response.Redirect("edit.asp") response.end else set rs3=conn.execute("select class_2.*,class_1.* from class_2,class_1 where class_2.typeid="&rs("typeid")&" and class_1.sortid=class_2.sortid") set rs9=conn.execute("select productclass_1.*,productclass.* from productclass_1,productclass where productclass_1.smallclassid="&rs("smallclassid")&" and productclass.bigclassid=productclass_1.bigclassid and productclass.gsid="&session("id")&" and productclass_1.gsid="&session("id")&"") set rs5=conn.execute("select name,ch,qymc,phone,fax,email from corporation where id="&session("id")&"") %>
|
|